Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Expiration Date' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to EXPIRATION DATE

Seq No	Page Number	Page Name	Control Name
1	38	Item Ledger Entries	Expiration Date
2	40	Item Journal	Expiration Date
3	167	Item Ledger Entries Preview	Expiration Date
4	283	Recurring General Journal	Expiration Date
5	286	Recurring Item Jnl.	Expiration Date
6	289	Recurring Job Jnl.	Expiration Date
7	290	Recurring Resource Jnl.	Expiration Date
8	296	Recurring Req. Worksheet	Expiration Date
9	3900	Retention Periods	Expiration Date
10	5206	Employee Qualifications	Expiration Date
11	5634	Recurring Fixed Asset Journal	Expiration Date
12	5644	Insurance Card	Expiration Date
13	5771	Whse. Put-away Subform	Expiration Date
14	5780	Whse. Pick Subform	Expiration Date
15	5796	Registered Put-away Subform	Expiration Date
16	5799	Registered Pick Subform	Expiration Date
17	6050	Service Contract	Expiration Date
18	6051	Service Contract List	Expiration Date
19	6053	Service Contract Quote	Expiration Date
20	6065	Customer Service Contracts	Expiration Date
21	6072	Filed Service Contract	Expiration Date
22	6500	Item Tracking Summary	Expiration Date
23	6501	Item Tracking Entries	Expiration Date
24	6507	Item Tracking List	Expiration Date
25	6510	Item Tracking Lines	Expiration Date
26	6511	Posted Item Tracking Lines	Expiration Date
27	6550	Whse. Item Tracking Lines	Expiration Date
28	7316	Warehouse Movement Subform	Expiration Date
29	7318	Warehouse Entries	Expiration Date
30	7326	Whse. Phys. Invt. Journal	Expiration Date
31	7350	Registered Movement Subform	Expiration Date
32	7376	Invt. Put-away Subform	Expiration Date
33	7378	Invt. Pick Subform	Expiration Date
34	7383	Invt. Movement Subform	Expiration Date
35	7385	Reg. Invt. Movement Subform	Expiration Date
36	7391	Posted Invt. Put-away Subform	Expiration Date
37	7393	Posted Invt. Pick Subform	Expiration Date
38	7396	Posted Invt. Put-away Lines	Expiration Date
39	7397	Posted Invt. Pick Lines	Expiration Date
40	9321	Service Contracts	Expiration Date
41	9322	Service Contract Quotes	Expiration Date
42	99000778	Recurring Capacity Journal	Expiration Date
43	99000827	Recurring Output Journal	Expiration Date
44	99000850	Recurring Consumption Journal	Expiration Date

Dynamics 365 BC Table ReferencePage Control Search